SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_GetSWGG]
	(
	@param_SubType VARCHAR(50)
	)
AS
	/* SET NOCOUNT ON */
	IF @param_SubType='swtz'
		SET @param_SubType='事务通知'
	ELSE
		IF @param_SubType='bszn'
		 SET @param_SubType='办事指南'
	SELECT TOP(8) JOL_Bulletin_No, JOL_Bulletin_Title,JOL_Bulletin_AddTime FROM dbo.JOL_Bulletin 
	WHERE JOL_Bulletin_SubType=@param_SubType
	ORDER BY JOL_Bulletin_IsSetTop DESC,JOL_Bulletin_AddTime Desc 
	RETURN
GO
